Release 10.1A: OpenEdge Data Management:
SQL Development

Configuring data sources on a UNIX environment

UNIX platforms utilize a file called odbc.ini to configure ODBC settings for an installation. A sample version for OpenEdge is provided in the $DLC/odbc directory. For example:

[ODBC Data Sources] sports=Progress_SQL_Driver [sports] Driver=/usr/dlc/odbc/lib/pgoe1021.so DatabaseName=default PortNumber=2055 HostName=localhost LogonID=testuser Password=xxx APILevel=1 ConnectFunctions=YYN CPTimeout=60 DriverODBCVer=03.50 FileUsage=0 SQLLevel=0 UsageCount=1 ArraySize=50 DefaultLongDataBuffLen=2048 DefaultIsolationLevel=REPEATABLE READ StaticCursorLongColBuffLen=4096 [ODBC] InstallDir=/usr/dlc/odbc Trace=0 TraceFile=odbctrace.out TraceDll=/usr/dlc/odbc/lib/odbctrac.so UseCursorLib=0

The first section, [ODBC Data Sources], contains a list of data sources available for an ODBC client. In this case, the data source name (DSN) is sports.

The following section, [sports], contains data-source-specific information for the DSN sports. The odbc.ini file should contain a section like this for each DSN the client might wish to use. The name of the DatabaseName, PortNumber, and HostName should be replaced with the unique DataSource Name, the HostName serving the database, the PortNumber, and Database Name identified during the preparation steps. For example:

[sports] Driver=/usr/dlc/odbc/lib/pgoe1021.so DatabaseName=mysports PortNumber=2055 HostName=myhost LogonID=testuser Password=xxx APILevel=1 ConnectFunctions=YYN CPTimeout=60 DriverODBCVer=03.50 FileUsage=0 SQLLevel=0 UsageCount=1 ArraySize=50 DefaultLongDataBuffLen=2048 DefaultIsolationLevel=REPEATABLE READ StaticCursorLongColBuffLen=4096